
Motivation
The report is developed to shed light on ethanol exports from Pakistan beginning year 2017.
Everything below is the result of computations performed on Ethanol Exports Database by computer program and displayed in the form of tables and charts. Where Microsoft Excel Dashboards have their weaknesses See Here and Microsoft Access reports are limited to desktops See Here,this method of reporting is not plagued by these weaknesses. Unlike Excel here the accuracy and consistency is guaranteed every time and reports can be constructed in an instant. With passing time I plan to make this more effective by adding some of my own insights to this and ensure that overall everything makes sense.
All prices of ethanol are in US Dollar on per metric ton basis indicated as M.Tons (Metric Tons).
Total observations from 2017 till date as below
Year Wise Summary
Ethanol Summary Year Wise
|
Year
|
Observations
|
Percent Contribution (%)
|
Value in Mil.USD
|
Qty in M.Tons
|
|
2021
|
1184
|
12.88
|
283.94
|
315531.2
|
|
2020
|
2169
|
23.60
|
262.68
|
303117.4
|
|
2019
|
2157
|
23.47
|
257.12
|
375839.8
|
|
2018
|
2015
|
21.93
|
371.37
|
552463.8
|
|
2017
|
1665
|
18.12
|
378.95
|
565612.6
|
Storage Wise Summary
Ethanol Summary by Mode of Shipment
|
Storage Type
|
Observations
|
Percent Contribution(%)
|
Value in Mil.USD
|
Qty in M.Tons
|
|
SMALL PACK
|
8218
|
89.42
|
403.60
|
486548.3
|
|
BULK
|
972
|
10.58
|
1150.46
|
1626016.4
|
Product Wise Summary
Ethanol Summary by Product
|
Product
|
Observations
|
Percent Contribution (%)
|
Value in Mil.USD
|
Qty in M.Tons
|
Max M.Ton Price
|
Min M.Ton Price
|
Mean M.Ton Price
|
Median M.Ton Price
|
|
ENA 96%
|
5351
|
58.23
|
1032.48
|
1357542.13
|
3379.13
|
465.00
|
864.25
|
845.00
|
|
B-Grade (94.5%-92.5%)
|
3044
|
33.12
|
399.20
|
580039.87
|
1015.88
|
370.50
|
737.20
|
730.81
|
|
Anhydrous 99%
|
622
|
6.77
|
22.24
|
25815.86
|
2043.00
|
665.00
|
882.46
|
823.69
|
|
Hydrous 95.8%
|
173
|
1.88
|
100.14
|
149166.86
|
1523.38
|
534.25
|
714.47
|
655.00
|
Regionwise Summary
Ethanol Summary by Region
|
REGION
|
Obs
|
Percentage Contribution(%)
|
Value in Mil.USD
|
Qty in M.Tons
|
Max.M.Ton Price
|
Min.M.Ton Price
|
Mean M.Ton Price
|
Median M.Ton Price
|
|
ASIA
|
5211
|
56.70
|
901.58
|
1288336.27
|
1891.37
|
370.50
|
769.91
|
731.00
|
|
AFRICA
|
1929
|
20.99
|
140.61
|
165637.09
|
1451.13
|
598.00
|
854.49
|
853.88
|
|
MIDDLE EAST
|
1505
|
16.38
|
108.36
|
113752.57
|
3379.13
|
500.00
|
969.64
|
900.00
|
|
EUROPE
|
448
|
4.87
|
400.92
|
542025.32
|
1685.00
|
487.50
|
750.98
|
695.00
|
|
AUSTRALIA
|
87
|
0.95
|
2.08
|
2374.81
|
1550.00
|
550.00
|
861.78
|
900.00
|
|
AMERICA
|
10
|
0.11
|
0.51
|
438.66
|
1867.87
|
720.38
|
1011.89
|
907.88
|

1. Trend Analysis
Quantitywise Trends
1. Month Wise Trend 
2. Product Wise Trend 
3. Region wise Trend 
4. Mode of Shipment By Quantity 
Valuewise Trends
1.Month Wise Trend

2.Product Trend 
3. Regionwise Trend 
4. Mode of Shipment Trend 
2. Analysis by Product
Data Distribution
The following table shows total product distribution
No. of Observations
|
Product
|
Observation
|
|
ENA 96%
|
5351
|
|
B-Grade (94.5%-92.5%)
|
3044
|
|
Anhydrous 99%
|
622
|
|
Hydrous 95.8%
|
173
|
The following table shows product distribution by year
No. of Observations
|
Year
|
ENA 96%
|
B-Grade (94.5%-92.5%)
|
Anhydrous 99%
|
Hydrous 95.8%
|
|
2021
|
1044
|
71
|
55
|
14
|
|
2020
|
1354
|
676
|
94
|
45
|
|
2019
|
1169
|
787
|
164
|
37
|
|
2018
|
899
|
881
|
194
|
41
|
|
2017
|
885
|
629
|
115
|
36
|
The following table shows product distribution by storage
No. of Observations
|
Product
|
SMALL PACK
|
BULK
|
|
ENA 96%
|
4703
|
648
|
|
B-Grade (94.5%-92.5%)
|
2816
|
228
|
|
Anhydrous 99%
|
620
|
2
|
|
Hydrous 95.8%
|
79
|
94
|
The following table shows product distribution by regions
No. of Observations
|
REGION
|
ENA 96%
|
B-Grade (94.5%-92.5%)
|
Anhydrous 99%
|
Hydrous 95.8%
|
|
ASIA
|
2968
|
1672
|
433
|
138
|
|
AFRICA
|
1010
|
914
|
NA
|
5
|
|
MIDDLE EAST
|
971
|
342
|
178
|
14
|
|
EUROPE
|
339
|
91
|
2
|
16
|
|
AUSTRALIA
|
55
|
24
|
8
|
NA
|
|
AMERICA
|
8
|
1
|
1
|
NA
|
The major contribution of exports from Pakistan are due to countries in
Among all regions in the world following has some of the highest prices overall
Product Wise Details Available Here 
Values in Million USD.
Value in Mil. USD
|
Product
|
2021
|
2020
|
2019
|
2018
|
2017
|
|
ENA 96%
|
257.17
|
191.40
|
158.02
|
209.30
|
216.58
|
|
B-Grade (94.5%-92.5%)
|
14.14
|
57.14
|
77.32
|
124.40
|
126.20
|
|
Hydrous 95.8%
|
9.58
|
10.16
|
15.23
|
32.37
|
32.80
|
|
Anhydrous 99%
|
3.05
|
3.98
|
6.54
|
5.30
|
3.37
|
Quantity in M.Ton(Thousands)
Quantity in Thousand M.Ton
|
Product
|
2021
|
2020
|
2019
|
2018
|
2017
|
|
ENA 96%
|
1029.18
|
1412.66
|
878.68
|
645.56
|
658.53
|
|
Anhydrous 99%
|
59.40
|
95.82
|
135.95
|
160.14
|
97.58
|
|
B-Grade (94.5%-92.5%)
|
49.45
|
531.46
|
580.93
|
639.24
|
442.95
|
|
Hydrous 95.8%
|
11.95
|
39.94
|
23.75
|
25.62
|
22.34
|
Data Distribution
The following table shows distribution of product over years
No. of Observations
|
Product
|
2017
|
2018
|
2019
|
2020
|
2021
|
|
ENA 96%
|
885
|
899
|
1169
|
1354
|
1044
|
|
B-Grade (94.5%-92.5%)
|
629
|
881
|
787
|
676
|
71
|
|
Anhydrous 99%
|
115
|
194
|
164
|
94
|
55
|
|
Hydrous 95.8%
|
36
|
41
|
37
|
45
|
14
|
3. Analysis by Region
Data Distribution
The following table shows total region distribution
No. of Observations
|
REGION
|
Observation
|
|
ASIA
|
5211
|
|
AFRICA
|
1929
|
|
MIDDLE EAST
|
1505
|
|
EUROPE
|
448
|
|
AUSTRALIA
|
87
|
|
AMERICA
|
10
|
The following table shows distribution of regions by year
No. of Observations
|
Year
|
ASIA
|
MIDDLE EAST
|
EUROPE
|
AFRICA
|
AUSTRALIA
|
AMERICA
|
|
2021
|
805
|
227
|
80
|
50
|
22
|
NA
|
|
2020
|
1026
|
587
|
131
|
393
|
28
|
4
|
|
2019
|
1131
|
291
|
70
|
645
|
16
|
4
|
|
2018
|
1209
|
240
|
82
|
474
|
9
|
1
|
|
2017
|
1040
|
160
|
85
|
367
|
12
|
1
|
The following table shows region distribution by storage
No. of Observations
|
REGION
|
SMALL PACK
|
BULK
|
|
ASIA
|
4637
|
574
|
|
AFRICA
|
1915
|
14
|
|
MIDDLE EAST
|
1462
|
43
|
|
EUROPE
|
107
|
341
|
|
AUSTRALIA
|
87
|
NA
|
|
AMERICA
|
10
|
NA
|
The following table shows distribution of regions by product
No. Of Observation
|
Product
|
ASIA
|
AFRICA
|
MIDDLE EAST
|
EUROPE
|
AUSTRALIA
|
AMERICA
|
|
ENA 96%
|
2968
|
1010
|
971
|
339
|
55
|
8
|
|
B-Grade (94.5%-92.5%)
|
1672
|
914
|
342
|
91
|
24
|
1
|
|
Anhydrous 99%
|
433
|
NA
|
178
|
2
|
8
|
1
|
|
Hydrous 95.8%
|
138
|
5
|
14
|
16
|
NA
|
NA
|
Highest prices can be seen from the graph below
Values in Million USD.
Value in Mil. USD
|
REGION
|
2021
|
2020
|
2019
|
2018
|
2017
|
|
ASIA
|
168.19
|
88.08
|
134.32
|
250.99
|
260.00
|
|
EUROPE
|
98.01
|
89.25
|
62.58
|
74.28
|
76.79
|
|
MIDDLE EAST
|
11.87
|
54.14
|
15.56
|
12.59
|
14.20
|
|
AFRICA
|
5.02
|
30.02
|
44.41
|
33.38
|
27.79
|
|
AUSTRALIA
|
0.86
|
0.76
|
0.20
|
0.11
|
0.15
|
|
AMERICA
|
NA
|
0.43
|
0.05
|
0.01
|
0.01
|
Quantity in M.Ton(Thousands)
Quantity in Thousand M.Ton
|
REGION
|
2021
|
2020
|
2019
|
2018
|
2017
|
|
ASIA
|
756.03
|
896.84
|
794.05
|
839.72
|
725.35
|
|
MIDDLE EAST
|
244.76
|
690.70
|
220.08
|
180.87
|
122.89
|
|
EUROPE
|
74.11
|
104.11
|
47.35
|
54.79
|
56.07
|
|
AFRICA
|
53.83
|
359.57
|
541.77
|
387.41
|
305.73
|
|
AUSTRALIA
|
21.26
|
23.81
|
12.62
|
6.78
|
10.49
|
|
AMERICA
|
NA
|
4.84
|
3.44
|
0.97
|
0.87
|
Regionwise Details Available Here 
Data Distribution
The following tables shows distribution of Regions over years
No.of Observation
|
REGION
|
2017
|
2018
|
2019
|
2020
|
2021
|
|
ASIA
|
1040
|
1209
|
1131
|
1026
|
805
|
|
AFRICA
|
367
|
474
|
645
|
393
|
50
|
|
MIDDLE EAST
|
160
|
240
|
291
|
587
|
227
|
|
EUROPE
|
85
|
82
|
70
|
131
|
80
|
|
AUSTRALIA
|
12
|
9
|
16
|
28
|
22
|
|
AMERICA
|
1
|
1
|
4
|
4
|
NA
|
4. Country wise Analysis
Data Distribution
Countries Available For Analysis
The following are the country wise contributions by year
The following are the country wise contributions by Product
The following are the country wise contributions by Storage
5. Exporter wise Analysis
Total Exporters Available For Analysis
Data Distribution
The following is the exporter wise contribution by Year
The following are the exporter wise contributions by Product
The following are the exporter wise contributions by Storage